<?php

/*
 * This file will perform the ajax for getting the department-position for the search results.
 * This is being used by admDeptPosSetup.php.
 * 
 * Created by: Peter Agno Jr.
 * Date created: November 28, 2011
 * 
 * In parameters: departmentId and positionId
 * Out parameters: department-position information for search results
 */

session_start();

// Start - Checker for those users who will just go to the page by typing directly in the url.
if ($_POST) {
    include('../includes/siteConfig.php');
    
    // connect to database
    $connect = mysql_connect($hostName,$rootName,$dBasePassword) or die ('Unable to connect!');
    mysql_select_db($dBaseName) or die ('Unable to select database!');

    // Get the data from post
    $departmentId = $_POST['departmentId'];
    $positionId = $_POST['positionId'];

    // Prepare filter of departmentId and positionId
    $filterDeptPos = "";
    if ( $departmentId != "All" ) {
        $filterDeptPos = "AND DP.departmentId = '" . $departmentId . "' ";
    }
    
    // Prepare filter for positionId
    if ( $positionId != "All" ) {
        $filterDeptPos = $filterDeptPos . "AND DP.positionId = '" . $positionId . "' ";
    }
    
    // Prepare the query for getting the department-position
    $query =
        "
            -- Filter Department and Position
            SELECT DP.deptPosId as deptPosId, D.departmentName as departmentName, P.positionName as positionName
            FROM Department_Position as DP, Department as D, Position as P
            WHERE DP.departmentId = D.departmentId
                AND DP.positionId = P.positionId
                ".$filterDeptPos."

            ORDER BY D.departmentName, P.positionName ASC
        ";
    $result = mysql_query($query) or die ('Error in query: $query. ' . mysql_error());
    
    // Identify if there were querried accounts
    if ( mysql_num_rows($result) > 0 ) {
        while ($row = mysql_fetch_array($result)) {
            $jsondata = array();
            $jsondata['deptPosId'] = $row['deptPosId'];
            $jsondata['departmentName'] = $row['departmentName']; 
            $jsondata['positionName'] = $row['positionName'];
            $feed[] = $jsondata;
        }
        
        echo json_encode($feed);
    }
    else {
        echo json_encode(0);
    }
    
    mysql_free_result($result);
    mysql_close($connect);
}   // End - Checker for those users who will just go to the page by typing directly in the url.
else {
    echo "You are not authorized to view this page. This incident will be reported immediately.";
}
?>
